create external table jms_dm.dm_sqs_fresh_call_detail_dt 
(
waybill_no                                              string COMMENT '运单号' ,
order_id                                                string COMMENT '订单id' ,
pick_agent_code                  string COMMENT '取件_代理区编码' ,
pick_agent_name                  string COMMENT '取件_代理区名称' ,
pick_site_code                                          string COMMENT '取件_网点名称' ,
pick_site_name                   string COMMENT '取件_网点名称name' ,
pick_city_id                     string COMMENT '取件_城市' ,
pick_city_desc                   string COMMENT '取件_城市name' ,
pick_area_id                     string COMMENT '取件_区县' ,
pick_area_desc                   string COMMENT '取件_区县name' ,
disp_agent_code                                        string COMMENT '派件_代理区编码' ,
disp_agent_name                                        string COMMENT '派件_代理区名称' ,
disp_site_code                                         string COMMENT '派件_网点名称' ,
disp_site_name                                         string COMMENT '派件_网点名称' ,
disp_city_id                                           string COMMENT '派件_城市' ,
disp_city_desc                                         string COMMENT '派件_城市name' ,
disp_area_id                                           string COMMENT '派件_区县' ,
disp_area_desc                                         string COMMENT '派件_区县name' ,
disp_zone_code                                         string COMMENT '派件_市场区name' ,
disp_zone_name                                         string COMMENT '派件_市场区name' ,
order_source_code                                       string COMMENT '订单来源code' ,
order_source_name                                       string COMMENT '订单来源name' ,
sign_big                                                string COMMENT '签收大类' ,
disp_time                                              timestamp COMMENT '签收时间' ,
disp_user_code                                         string COMMENT '派件员' ,
disp_user_name                                         string COMMENT '派件员code' ,
is_reback                                               string COMMENT '是否退件' ,
is_call                                   string COMMENT '通话状态1是/0否' ,
intelligent_flag                  string COMMENT '是否智能外乎' ,
call_number                                            bigint COMMENT '拨打次数' ,
call_time      timestamp COMMENT '通话时间' ,
is_complaint0)  is_complaint                                           string COMMENT '是否客诉' ,
call_flg_10)      call_flg_1                                         string COMMENT '已接通本方挂断' ,
call_flg_2 0)      call_flg_2                                       string COMMENT '已接通对方挂断' ,
call_flg_30)      call_flg_3                                        string COMMENT '接通总票数' ,
date_time                                              timestamp COMMENT 'date_time' )
comment 'insert overwrite table jms_dm.dm_sqs_fresh_call_detail_dt partition (dt)'
PARTITIONED BY ( dt string COMMENT '时间分区')
stored as parquet
LOCATION '/dw/hive/jms_dm.db/external/dm_sqs_fresh_call_detail_dt'
TBLPROPERTIES (     'discover.partitions' = 'false',  'parquet.column.index.access' = 'true');
